--
-- PostgreSQL database dump
--

-- Started on 2008-08-15 13:48:06

SET client_encoding = 'UTF8';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 1522 (class 1259 OID 64131)
-- Dependencies: 3
-- Name: e_company; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE e_company (
    e_company_id integer NOT NULL,
    code text,
    topic text,
    accessionno character(25) NOT NULL
);


ALTER TABLE public.e_company OWNER TO postgres;

--
-- TOC entry 1521 (class 1259 OID 64129)
-- Dependencies: 1522 3
-- Name: e_company_e_company_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE e_company_e_company_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE public.e_company_e_company_id_seq OWNER TO postgres;

--
-- TOC entry 1816 (class 0 OID 0)
-- Dependencies: 1521
-- Name: e_company_e_company_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE e_company_e_company_id_seq OWNED BY e_company.e_company_id;


--
-- TOC entry 1817 (class 0 OID 0)
-- Dependencies: 1521
-- Name: e_company_e_company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('e_company_e_company_id_seq', 299, true);


--
-- TOC entry 1809 (class 2604 OID 64134)
-- Dependencies: 1521 1522 1522
-- Name: e_company_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE e_company ALTER COLUMN e_company_id SET DEFAULT nextval('e_company_e_company_id_seq'::regclass);


--
-- TOC entry 1813 (class 0 OID 64131)
-- Dependencies: 1522
-- Data for Name: e_company; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY e_company (e_company_id, code, topic, accessionno) FROM stdin;
1	ccred	Citigroup Inc	YOMSHI0020080117e41h00001
2	mcjap	McDonald's Holdings Co (Japan) Ltd	YOMSHI0020080129e41t00001
3	bigmac	McDonald's Corporation	YOMSHI0020080129e41t00001
4	ntia	Narita International Airport Corporation	YOMSHI0020080209e42900001
5	matsu	Matsushita Electric Industrial Co., Ltd	YOMSHI0020080213e42d00001
6	epd	Electric Power Development Co Ltd	YOMSHI0020080224e42o00001
7	kdnsha	KODANSHA LTD PUBLISHERS	YOMSHI0020080411e44b00001
8	paccg	Pacific Consultants International Group	YOMSHI0020080424e44o00004
9	yoshin	Yoshinoya Holdings Co., Ltd.	YOMSHI0020080425e44p00001
10	fujya	Fujiya Co Ltd	YOMSHI0020070114e31e00001
11	spcol	Space Co Ltd	YOMSHI0020070121e31l00001
12	kjma	Kajima Corp	YOMSHI0020070123e31n00001
13	ohbg	Obayashi Corp	YOMSHI0020070123e31n00001
14	shmz	Shimizu Corporation	YOMSHI0020070123e31n00001
15	gzprm	OAO Gazprom	YOMSHI0020070129e31t00001
16	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020070201e32100001
17	sapbr	Sapporo Holdings Ltd	YOMSHI0020070217e32h00001
18	yamha	Yamaha Motor Co Ltd	YOMSHI0020070226e32q00001
19	hazama	Hazama Corp	YOMSHI0020070302e33200002
20	kjma	Kajima Corp	YOMSHI0020070302e33200002
21	ohbg	Obayashi Corp	YOMSHI0020070302e33200002
22	shmz	Shimizu Corporation	YOMSHI0020070302e33200002
23	ccred	Citigroup Inc	YOMSHI0020070307e3380000n
24	niksec	Nikko Cordial Corp	YOMSHI0020070307e3380000n
25	niksec	Nikko Cordial Corp	YOMSHI0020070313e33d00002
26	tokse	Tokyo Stock Exchange Inc	YOMSHI0020070313e33d00002
27	lionth	livedoor Co Ltd	YOMSHI0020070317e33h00001
28	dnp	Dai Nippon Printing Co Ltd	YOMSHI0020070318e33i00001
29	npndns	Denso Corp	YOMSHI0020070320e33k00001
30	sapbr	Sapporo Holdings Ltd	YOMSHI0020070330e33u00001
31	ccred	Citigroup Inc	YOMSHI0020070428e34s00001
32	niksec	Nikko Cordial Corp	YOMSHI0020070428e34s00001
33	hoyc	Hoya Corporation	YOMSHI0020070522e35m00001
34	pntxuk	Pentax Corp	YOMSHI0020070522e35m00001
35	gdwill	The Goodwill Group Inc	YOMSHI0020070607e36700002
36	japasy	Japan Airlines Corporation	YOMSHI0020070615e36f00001
37	nyfsb	New York Federal Savings Bank	YOMSHI0020070616e36g00002
38	budosa	Bull-Dog Sauce Co Ltd	YOMSHI0020070627e36r00002
39	rakinc	Rakuten Inc	YOMSHI0020070630e36u00001
40	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020070719e37j00002
41	nippob	Nippon Broadcasting System Inc	YOMSHI0020070720e37k00001
42	fujtel	Fuji Television Network Inc	YOMSHI0020070720e37k00001
43	ricko	Riken Corp	YOMSHI0020070725e37p00001
44	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020070726e37q00003
45	isetn	Isetan Co Ltd	YOMSHI0020070727e37r00001
46	dowjon	Dow Jones & Company Inc	YOMSHI0020070804e38400001
47	newsc	News Corporation	YOMSHI0020070804e38400001
48	tokcet	The Tokyo Commodity Exchange	YOMSHI0020070805e38500001
49	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020070807e38700001
50	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020070822e38m00001
51	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020070825e38p00001
52	jappo	Japan Post	YOMSHI0020070927e39r00001
53	chbelp	Chubu Electric Power Co Inc	YOMSHI0020071027e3ar00001
54	hokel	Hokuriku Electric Power Co	YOMSHI0020071027e3ar00001
55	novaco	Nova Corp	YOMSHI0020071028e3as00001
56	novaco	Nova Corp	YOMSHI0020071112e3bb00001
57	yys	Yamada Corp	YOMSHI0020071116e3bg00002
58	yys	Yamada Corp	YOMSHI0020071129e3bt00001
59	yys	Yamada Corp	YOMSHI0020071219e3cj00001
60	fujya	Fujiya Co Ltd	YOMSHI0020071225e3cp00001
61	jnfl	Japan Nuclear Fuel Ltd	YOMSHI0020060110e21b0000h
62	lionth	livedoor Co Ltd	YOMSHI0020060116e21h0000i
63	vaclja	livedoor MARKETING Co., Ltd.	YOMSHI0020060116e21h0000i
64	lionth	livedoor Co Ltd	YOMSHI0020060118e21j0000g
65	tokse	Tokyo Stock Exchange Inc	YOMSHI0020060118e21j0000g
66	lionth	livedoor Co Ltd	YOMSHI0020060123e21o0000a
67	nhk	NHK	YOMSHI0020060125e21q0000g
68	lionth	livedoor Co Ltd	YOMSHI0020060126e21r0000c
69	lionth	livedoor Co Ltd	YOMSHI0020060130e21v0000g
70	yamha	Yamaha Motor Co Ltd	YOMSHI0020060207e2280000j
71	mityo	Mitutoyo Corp	YOMSHI0020060216e22h0000h
72	arcelo	Arcelor SA	YOMSHI0020060220e22l0000k
73	isptnl	Mittal Steel Company NV	YOMSHI0020060220e22l0000k
74	mitgrp	The LNM Group	YOMSHI0020060220e22l0000k
75	lionth	livedoor Co Ltd	YOMSHI0020060223e22n00001
76	lionth	livedoor Co Ltd	YOMSHI0020060224e22p0000b
77	japasy	Japan Airlines Corporation	YOMSHI0020060227e22r00001
78	lionth	livedoor Co Ltd	YOMSHI0020060228e2310000e
79	lionth	livedoor Co Ltd	YOMSHI0020060313e23e0000o
80	tokse	Tokyo Stock Exchange Inc	YOMSHI0020060313e23e0000o
81	toyta	Toyota Motor Corp	YOMSHI0020060315e23g0000j
82	kjma	Kajima Corp	YOMSHI0020060316e23h0000d
83	ohbg	Obayashi Corp	YOMSHI0020060316e23h0000d
84	shmz	Shimizu Corporation	YOMSHI0020060316e23h0000d
85	tais	Taisei Corp	YOMSHI0020060316e23h0000d
86	lionth	livedoor Co Ltd	YOMSHI0020060322e23n0000l
87	hokel	Hokuriku Electric Power Co	YOMSHI0020060324e23p0000l
88	japasy	Japan Airlines Corporation	YOMSHI0020060325e23q0000g
89	kanelp	The Kansai Electric Power Co Inc	YOMSHI0020060327e23s0000i
90	kyelp	Kyushu Electric Power Co Inc	YOMSHI0020060327e23s0000i
91	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020060327e23s0000i
92	jnfl	Japan Nuclear Fuel Ltd	YOMSHI0020060401e2420000g
93	aifulc	Aiful Corp	YOMSHI0020060414e24f0000i
94	ebco	Ebara Corp	YOMSHI0020060418e24j0000l
95	htzosn	Hitachi Zosen Corp	YOMSHI0020060418e24j0000l
96	kuwa	Kurita Water Industries Ltd	YOMSHI0020060418e24j0000l
97	wstral	West Japan Railway Co	YOMSHI0020060424e24o00002
98	jarail	Japan Railways Group	YOMSHI0020060424e24o00002
99	ntt	Nippon Telegraph and Telephone Corp	YOMSHI0020060503e2540000a
100	kanbo	Kanebo Ltd	YOMSHI0020060509e25900003
101	kokudc	Kokudo Corporation	YOMSHI0020060509e25900003
102	lionth	livedoor Co Ltd	YOMSHI0020060509e25900003
103	ntt	Nippon Telegraph and Telephone Corp	YOMSHI0020060522e25m00003
104	lionth	livedoor Co Ltd	YOMSHI0020060526e25r0000b
105	hancor	Hankyu Holdings, Inc.	YOMSHI0020060529e25u0000d
106	hanel	Hanshin Electric Railway Co Ltd	YOMSHI0020060529e25u0000d
107	fujtel	Fuji Television Network Inc	YOMSHI0020060602e2630000f
108	lionth	livedoor Co Ltd	YOMSHI0020060602e2630000f
109	nippob	Nippon Broadcasting System Inc	YOMSHI0020060602e2630000f
110	lionth	livedoor Co Ltd	YOMSHI0020060606e26600001
111	nippob	Nippon Broadcasting System Inc	YOMSHI0020060606e26600001
112	fujtel	Fuji Television Network Inc	YOMSHI0020060606e26600001
113	tmfin	Mitsui Sumitomo Insurance Co	YOMSHI0020060623e26n00002
114	lionth	livedoor Co Ltd	YOMSHI0020060623e26o0000j
115	nippob	Nippon Broadcasting System Inc	YOMSHI0020060623e26o0000j
116	fujtel	Fuji Television Network Inc	YOMSHI0020060623e26o0000j
117	arcelo	Arcelor SA	YOMSHI0020060627e26s0000g
118	isptnl	Mittal Steel Company NV	YOMSHI0020060627e26s0000g
119	mitgrp	The LNM Group	YOMSHI0020060627e26s0000g
120	gnmoc	General Motors Corp	YOMSHI0020060715e27g0000b
121	nisan	Nissan Motor Co Ltd	YOMSHI0020060715e27g0000b
122	rnltl	Renault SA	YOMSHI0020060715e27g0000b
123	trcnda	Tracinda Corp	YOMSHI0020060715e27g0000b
124	dai	The Daiei Inc	YOMSHI0020060731e27v00001
125	ircj	Industrial Revitalization Corp. of Japan	YOMSHI0020060731e27v00001
126	mrubni	Marubeni Corp	YOMSHI0020060731e27v00001
127	jappo	Japan Post	YOMSHI0020060801e28100001
128	kanbo	Kanebo Ltd	YOMSHI0020060810e28a00001
129	prwth	PricewaterhouseCoopers	YOMSHI0020060810e28a00001
130	mityo	Mitutoyo Corp	YOMSHI0020060826e28q00001
131	lionth	livedoor Co Ltd	YOMSHI0020060905e29500001
132	nhk	NHK	YOMSHI0020061111e2bb00001
133	jappo	Japan Post	YOMSHI0020061128e2bs00001
134	dnddk	KDDI Corp	YOMSHI0020061213e2cd00001
135	nttmcn	NTT DoCoMo Inc	YOMSHI0020061213e2cd00001
136	wincoj	Willcom Inc	YOMSHI0020061213e2cd00001
137	crlylg	The Carlyle Group	YOMSHI0020061213e2cd00001
138	ntt	Nippon Telegraph and Telephone Corp	YOMSHI0020061213e2cd00001
139	kanelp	The Kansai Electric Power Co Inc	YOMSHI0020061230e2cu00001
140	nichch	Nichia Corporation	YOMSHI0020050111e11c0000g
141	jappo	Japan Post	YOMSHI0020050119e11k0000f
142	jappo	Japan Post	YOMSHI0020050121e11m0000h
143	mitmot	Mitsubishi Motors Corp	YOMSHI0020050128e11t0000j
144	mitsu	Mitsubishi Heavy Industries Ltd	YOMSHI0020050128e11t0000j
145	donen	Japan Nuclear Cycle Development Institute	YOMSHI0020050207e1280000d
146	lionth	livedoor Co Ltd	YOMSHI0020050209e12a0000j
147	nippob	Nippon Broadcasting System Inc	YOMSHI0020050209e12a0000j
148	fujsan	FUJISANKEI COMMUNICATIONS	YOMSHI0020050209e12a0000j
149	hounat	HOUSING LOAN CORP	YOMSHI0020050220e12l00009
150	lionth	livedoor Co Ltd	YOMSHI0020050223e12o0000i
151	nippob	Nippon Broadcasting System Inc	YOMSHI0020050223e12o0000i
152	fujsan	FUJISANKEI COMMUNICATIONS	YOMSHI0020050223e12o0000i
153	smfgpi	Sumitomo Mitsui Financial Group Inc	YOMSHI0020050301e1320000e
154	dai	The Daiei Inc	YOMSHI0020050302e1330000k
155	ircj	Industrial Revitalization Corp. of Japan	YOMSHI0020050302e1330000k
156	maru	The Maruetsu Inc	YOMSHI0020050302e1330000k
157	mrubni	Marubeni Corp	YOMSHI0020050302e1330000k
158	kokudc	Kokudo Corporation	YOMSHI0020050303e1340000f
159	fujsan	FUJISANKEI COMMUNICATIONS	YOMSHI0020050308e1390000e
160	fujtel	Fuji Television Network Inc	YOMSHI0020050308e1390000e
161	lionth	livedoor Co Ltd	YOMSHI0020050308e1390000e
162	nippob	Nippon Broadcasting System Inc	YOMSHI0020050308e1390000e
163	fujtel	Fuji Television Network Inc	YOMSHI0020050311e13c0000m
164	lionth	livedoor Co Ltd	YOMSHI0020050311e13c0000m
165	nippob	Nippon Broadcasting System Inc	YOMSHI0020050311e13c0000m
166	fujsan	FUJISANKEI COMMUNICATIONS	YOMSHI0020050311e13c0000m
167	fujsan	FUJISANKEI COMMUNICATIONS	YOMSHI0020050323e13o0000e
168	fujtel	Fuji Television Network Inc	YOMSHI0020050323e13o0000e
169	lionth	livedoor Co Ltd	YOMSHI0020050323e13o0000e
170	nippob	Nippon Broadcasting System Inc	YOMSHI0020050323e13o0000e
171	kokudc	Kokudo Corporation	YOMSHI0020050326e13r0000g
172	mizucb	Mizuho Corporate Bank Ltd	YOMSHI0020050326e13r0000g
173	mizfin	Mizuho Financial Group Inc	YOMSHI0020050326e13r0000g
174	jappo	Japan Post	YOMSHI0020050402e1430000f
175	jappo	Japan Post	YOMSHI0020050404e1450000f
176	fujtel	Fuji Television Network Inc	YOMSHI0020050422e14j00005
177	lionth	livedoor Co Ltd	YOMSHI0020050422e14j00005
178	nippob	Nippon Broadcasting System Inc	YOMSHI0020050422e14j00005
179	fujsan	FUJISANKEI COMMUNICATIONS	YOMSHI0020050422e14j00005
180	fujtel	Fuji Television Network Inc	YOMSHI0020050424e14p0000e
181	lionth	livedoor Co Ltd	YOMSHI0020050424e14p0000e
182	nippob	Nippon Broadcasting System Inc	YOMSHI0020050424e14p0000e
183	fujsan	FUJISANKEI COMMUNICATIONS	YOMSHI0020050424e14p0000e
184	jarail	Japan Railways Group	YOMSHI0020050425e14q0000f
185	wstral	West Japan Railway Co	YOMSHI0020050425e14q0000f
186	jappo	Japan Post	YOMSHI0020050427e14s0000f
187	wstral	West Japan Railway Co	YOMSHI0020050506e1570000j
188	jarail	Japan Railways Group	YOMSHI0020050506e1570000j
189	wstral	West Japan Railway Co	YOMSHI0020050515e15g0000c
190	jarail	Japan Railways Group	YOMSHI0020050515e15g0000c
191	jappo	Japan Post	YOMSHI0020050520e15l0000k
192	njap	Shinko Securities Co Ltd	YOMSHI0020050521e15m0000g
193	intbmc	Mastercard Inc	YOMSHI0020050622e16n0000h
194	hokep	Hokkaido Electric Power Co Inc	YOMSHI0020050623e16o0000i
195	mitsel	Mitsubishi Electric Corp	YOMSHI0020050623e16o0000i
196	jappo	Japan Post	YOMSHI0020050713e17e0000h
197	teko	Teikoku Oil Co Ltd	YOMSHI0020050714e17f0000d
198	jhpc	Japan Highway Public Corp	YOMSHI0020050725e17q0000e
199	jappo	Japan Post	YOMSHI0020050729e17u0000k
200	japeng	Japan Engineering Consultants Co Ltd	YOMSHI0020050730e17v0000f
201	chno	CHINA NATIONAL OFFSHORE OIL	YOMSHI0020050808e18700001
202	cnooc	CNOOC Ltd	YOMSHI0020050808e18700001
203	unol	Unocal Corp	YOMSHI0020050808e18700001
204	jappo	Japan Post	YOMSHI0020050824e18p0000e
205	wstral	West Japan Railway Co	YOMSHI0020050906e1970000j
206	jarail	Japan Railways Group	YOMSHI0020050906e1970000j
207	jappo	Japan Post	YOMSHI0020050913e19e0000h
208	jhpc	Japan Highway Public Corp	YOMSHI0020050929e19u0000g
209	fhi	Fuji Heavy Industries Ltd	YOMSHI0020051006e1a70000l
210	gnmoc	General Motors Corp	YOMSHI0020051006e1a70000l
211	toyta	Toyota Motor Corp	YOMSHI0020051006e1a70000l
212	rakinc	Rakuten Inc	YOMSHI0020051014e1af0000j
213	tokbs	Tokyo Broadcasting System Inc	YOMSHI0020051014e1af0000j
214	jappo	Japan Post	YOMSHI0020051015e1ag0000a
215	rakinc	Rakuten Inc	YOMSHI0020051023e1ao0000d
216	cnon	Canon Inc	YOMSHI0020051107e1b80000k
217	japfin	Japan Finance Corp for Municipal Enterprises	YOMSHI0020051122e1bn0000i
218	tokse	Tokyo Stock Exchange Inc	YOMSHI0020051123e1bo0000b
219	rakinc	Rakuten Inc	YOMSHI0020051201e1c20000h
220	tokbs	Tokyo Broadcasting System Inc	YOMSHI0020051201e1c20000h
221	jcomjp	J-COM Co.,Ltd.	YOMSHI0020051221e1cm0000i
222	mizsec	Mizuho Securities Co Ltd	YOMSHI0020051221e1cm0000i
223	nmsc	Nomura Securities Co Ltd	YOMSHI0020051221e1cm0000i
224	ubsjap	UBS Securities Japan Ltd	YOMSHI0020051221e1cm0000i
225	mizfin	Mizuho Financial Group Inc	YOMSHI0020051221e1cm0000i
226	dlnred	UBS Investment Bank	YOMSHI0020051221e1cm0000i
227	nomsec	Nomura Holdings Inc	YOMSHI0020051221e1cm0000i
228	ubs	UBS AG	YOMSHI0020051221e1cm0000i
229	japral	East Japan Railway Co	YOMSHI0020051228e1cr00001
230	wstral	West Japan Railway Co	YOMSHI0020051228e1cr00001
231	jarail	Japan Railways Group	YOMSHI0020051228e1cr00001
232	ltcb	SHINSEI BANK LTD	YOMSHI0020040219e02k0000e
233	rwood	Ripplewood Holdings LLC	YOMSHI0020040219e02k0000e
234	mftbc	Mitsubishi Fuso Truck & Bus Corp	YOMSHI0020040311e03c0000g
235	mitmot	Mitsubishi Motors Corp	YOMSHI0020040311e03c0000g
236	kanelp	The Kansai Electric Power Co Inc	YOMSHI0020040315e03g0000h
237	toyta	Toyota Motor Corp	YOMSHI0020040320e03l0000c
238	mitmot	Mitsubishi Motors Corp	YOMSHI0020040506e0570000j
239	hond	Honda Motor Co Ltd	YOMSHI0020040512e05d0000i
240	nisan	Nissan Motor Co Ltd	YOMSHI0020040512e05d0000i
241	toyta	Toyota Motor Corp	YOMSHI0020040512e05d0000i
242	natam	National Amusements Inc	YOMSHI0020040525e05q0000i
243	jhpc	Japan Highway Public Corp	YOMSHI0020040602e0630000e
244	mitmot	Mitsubishi Motors Corp	YOMSHI0020040603e0640000h
245	jnfl	Japan Nuclear Fuel Ltd	YOMSHI0020040618e06j0000h
246	snyco	Sony Corp	YOMSHI0020040629e06u0000l
247	toyta	Toyota Motor Corp	YOMSHI0020040629e06u0000l
248	mitfin	Mitsubishi Tokyo Financial Group Inc	YOMSHI0020040714e07f0000i
249	ufjhol	UFJ Holdings Inc	YOMSHI0020040714e07f0000i
250	kanelp	The Kansai Electric Power Co Inc	YOMSHI0020040815e08g0000g
251	jappo	Japan Post	YOMSHI0020040827e08s0000j
252	kanelp	The Kansai Electric Power Co Inc	YOMSHI0020040902e0930000b
253	jappo	Japan Post	YOMSHI0020040907e0980000f
254	jappo	Japan Post	YOMSHI0020040910e09b0000h
255	jappo	Japan Post	YOMSHI0020041023e0ao0000b
256	pbchin	PEOPLE'S BANK OF CHINA	YOMSHI0020041101e0b20000i
257	kinknr	Kintetsu Corporation	YOMSHI0020041102e0b30000d
258	lionth	livedoor Co Ltd	YOMSHI0020041102e0b30000d
259	rakinc	Rakuten Inc	YOMSHI0020041102e0b30000d
260	kiybnk	Kiyo Bank Ltd	YOMSHI0020041127e0bs0000d
261	wakybk	Wakayama Bank	YOMSHI0020041127e0bs0000d
262	jnfl	Japan Nuclear Fuel Ltd	YOMSHI0020041222e0cn0000h
263	dai	The Daiei Inc	YOMSHI0020041229e0cu0000e
264	ircj	Industrial Revitalization Corp. of Japan	YOMSHI0020041229e0cu0000e
265	tkyelc	The Tokyo Electric Power Co Inc	YOMSHI0020030831dz910000c
266	bkjap	Bank of Japan	YOMSHI0020030912dz9d0000e
267	hounat	HOUSING LOAN CORP	YOMSHI0020030912dz9d0000e
268	bkjap	Bank of Japan	YOMSHI0020030918dz9j0000g
269	hexpub	HANSHIN EXPRESSWAY PUBLIC CORP	YOMSHI0020030923dz9o0000c
270	jhpc	Japan Highway Public Corp	YOMSHI0020030923dz9o0000c
271	bkjap	Bank of Japan	YOMSHI0020031001dza20000i
272	bkjap	Bank of Japan	YOMSHI0020031008dza90000h
273	jhpc	Japan Highway Public Corp	YOMSHI0020031009dzaa0000e
274	jappo	Japan Post	YOMSHI0020031011dzac0000d
275	lorspc	Loral Space & Communications Ltd	YOMSHI0020031112dzbd0000d
276	ircj	Industrial Revitalization Corp. of Japan	YOMSHI0020031120dzbl0000g
277	bkjap	Bank of Japan	YOMSHI0020031128dzbt0003a
278	ashfig	Ashikaga Financial Group Inc	YOMSHI0020031129dzbu0000c
279	RECCO	RECRUIT CO LTD (JAP)	yomshi0020030304dz350005p
280	TKYELC	TOKYO ELECTRIC POWER,THE CO INC (JAP)	yomshi0020030317dz3f000bf
281	JAPPO		yomshi0020030402dz4200004
282	CERBGP	CERBERUS GROUP (USA)	yomshi0020030414dz4f000mc
283	NPONCB	AOZORA BANK LTD (JAP)	yomshi0020030414dz4f000mc
284	SFTBNK	SOFTBANK CORP (JAP)	yomshi0020030414dz4f000mc
285	DAIHOL		yomshi0020030518dz5i000bb
286	DAIHOL		yomshi0020030519dz5j00004
287	DAIHOL		yomshi0020030626dz6b00007
288	MIZBNK	MIZUHO HOLDINGS INC (JAP)	yomshi0020020408dy470005t
289	JAPAL	JAPAN AIRLINES COMPANY LTD (JAP)	yomshi0020020429dy4r000by
290	TDA	JAPAN AIR SYSTEM CO (JAP)	yomshi0020020429dy4r000by
291	JNOCC	JAPAN NATIONAL OIL CORPORATION (JAP)	yomshi0020020507dy560000c
292	TOYTA	TOYOTA MOTOR CORP (JAP)	yomshi0020020529dy5t0001g
293	JHPC	JAPAN HIGHWAY PUBLIC CORP (JAP)	yomshi0020020617dy6g00060
294	ADVCOS	WORLDCOM INC WORLDCOM GROUP (USA)	yomshi0020020723dy7n0005t
295	JHPC	JAPAN HIGHWAY PUBLIC CORP (JAP)	yomshi0020020730dy7t0005t
296	TOYTA	TOYOTA MOTOR CORP (JAP)	yomshi0020020813dy8e000bd
297	NMEAT	NIPPON MEAT PACKERS INC (JAP)	yomshi0020020816dy8g00007
298	NMEAT	NIPPON MEAT PACKERS INC (JAP)	yomshi0020020821dy8l0000a
299	TKYELC	TOKYO ELECTRIC POWER,THE CO INC (JAP)	yomshi0020021121dybl0000a
\.


--
-- TOC entry 1811 (class 2606 OID 64139)
-- Dependencies: 1522 1522
-- Name: e_company_pk; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY e_company
    ADD CONSTRAINT e_company_pk PRIMARY KEY (e_company_id);


--
-- TOC entry 1812 (class 2606 OID 64140)
-- Dependencies: 1519 1522
-- Name: e_company_accessionno_fk; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY e_company
    ADD CONSTRAINT e_company_accessionno_fk FOREIGN KEY (accessionno) REFERENCES e_editorial(accessionno);


-- Completed on 2008-08-15 13:48:06

--
-- PostgreSQL database dump complete
--

